CREATE EXTERNAL TABLE jms_dm.dm_transit_violation_waybill_volume
(
    waybill_no string comment '运单号',
    volume     decimal(16, 4) comment '体积最小',
    dtype      int comment '类型：1、包内件 2：散单',
    seq_num    int comment '排序asc'
) COMMENT '45天包件体积'
    STORED AS PARQUET
    LOCATION '/dw/hive/jms_dm.db/external/dm_transit_violation_waybill_volume'
    TBLPROPERTIES (
        'discover.partitions' = 'false',
        'parquet.column.index.access' = 'true'
        );